MongoDB Common Use

数据库连接

# connection
mongo "mongodb://root:[email protected]:27017/"

删除重复数据

// delete dupilicate keys
db.qy_user
  .aggregate([
    {
      $group: {
        _id: { user_id: '$user_id' },
        dups: { $push: '$_id' },
        count: { $sum: 1 }
      }
    },
    { $match: { count: { $gt: 1 } } }
  ])
  .forEach(function(doc) {
    doc.dups.shift()
    db.qy_user.remove({ _id: { $in: doc.dups } })
  })

// create unique index
db.wm_user.createIndex(
  {
    pid: 1
  },
  {
    unique: true
  }
)
// create user
db.createUser({
  user: 'savvy',
  pwd: 'savvy',
  roles: [
    {
      role: 'readWrite',
      db: 'savvy_cloud_metadata'
    }
  ]
})
// create index filter some columns
db.standard_hotel_aggregate.createIndex(
  {
    "info.bindedMap.meituan": 1,
  },
  {
    unique: true,
    partialFilterExpression: {
      'info.bindedMap.meituan': {
        $type: 'string',
      },
    },
  }
)

db.test.createIndex(
  {
    test: 1,
  },
  {
    unique: true,
    partialFilterExpression: {
      test: {
        $type: 'string',
      },
    },
  }
)

根据类型建立索引

db.aggregation_hotels.createIndex(
  {
    'bindMap.bestwehotel': 1,
  },
  {
    unique: true,
    partialFilterExpression: {
      'bindMap.bestwehotel': {
        $type: 'string',
      },
    },
  }
)